package cn.edu.zjgsu.ito.model;

import java.util.ArrayList;
import java.util.Date;
import java.util.Iterator;
import java.util.List;

public class OrderNoCourierExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public OrderNoCourierExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        protected void addCriterionForJDBCDate(String condition, Date value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            addCriterion(condition, new java.sql.Date(value.getTime()), property);
        }

        protected void addCriterionForJDBCDate(String condition, List<Date> values, String property) {
            if (values == null || values.size() == 0) {
                throw new RuntimeException("Value list for " + property + " cannot be null or empty");
            }
            List<java.sql.Date> dateList = new ArrayList<java.sql.Date>();
            Iterator<Date> iter = values.iterator();
            while (iter.hasNext()) {
                dateList.add(new java.sql.Date(iter.next().getTime()));
            }
            addCriterion(condition, dateList, property);
        }

        protected void addCriterionForJDBCDate(String condition, Date value1, Date value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            addCriterion(condition, new java.sql.Date(value1.getTime()), new java.sql.Date(value2.getTime()), property);
        }

        public Criteria andUserIdIsNull() {
            addCriterion("user_id is null");
            return (Criteria) this;
        }

        public Criteria andUserIdIsNotNull() {
            addCriterion("user_id is not null");
            return (Criteria) this;
        }

        public Criteria andUserIdEqualTo(Integer value) {
            addCriterion("user_id =", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdNotEqualTo(Integer value) {
            addCriterion("user_id <>", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdGreaterThan(Integer value) {
            addCriterion("user_id >", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("user_id >=", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdLessThan(Integer value) {
            addCriterion("user_id <", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdLessThanOrEqualTo(Integer value) {
            addCriterion("user_id <=", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdIn(List<Integer> values) {
            addCriterion("user_id in", values, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdNotIn(List<Integer> values) {
            addCriterion("user_id not in", values, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdBetween(Integer value1, Integer value2) {
            addCriterion("user_id between", value1, value2, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdNotBetween(Integer value1, Integer value2) {
            addCriterion("user_id not between", value1, value2, "userId");
            return (Criteria) this;
        }

        public Criteria andExpectedArrivalTimeIsNull() {
            addCriterion("expected_arrival_time is null");
            return (Criteria) this;
        }

        public Criteria andExpectedArrivalTimeIsNotNull() {
            addCriterion("expected_arrival_time is not null");
            return (Criteria) this;
        }

        public Criteria andExpectedArrivalTimeEqualTo(Date value) {
            addCriterion("expected_arrival_time =", value, "expectedArrivalTime");
            return (Criteria) this;
        }

        public Criteria andExpectedArrivalTimeNotEqualTo(Date value) {
            addCriterion("expected_arrival_time <>", value, "expectedArrivalTime");
            return (Criteria) this;
        }

        public Criteria andExpectedArrivalTimeGreaterThan(Date value) {
            addCriterion("expected_arrival_time >", value, "expectedArrivalTime");
            return (Criteria) this;
        }

        public Criteria andExpectedArrivalTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("expected_arrival_time >=", value, "expectedArrivalTime");
            return (Criteria) this;
        }

        public Criteria andExpectedArrivalTimeLessThan(Date value) {
            addCriterion("expected_arrival_time <", value, "expectedArrivalTime");
            return (Criteria) this;
        }

        public Criteria andExpectedArrivalTimeLessThanOrEqualTo(Date value) {
            addCriterion("expected_arrival_time <=", value, "expectedArrivalTime");
            return (Criteria) this;
        }

        public Criteria andExpectedArrivalTimeIn(List<Date> values) {
            addCriterion("expected_arrival_time in", values, "expectedArrivalTime");
            return (Criteria) this;
        }

        public Criteria andExpectedArrivalTimeNotIn(List<Date> values) {
            addCriterion("expected_arrival_time not in", values, "expectedArrivalTime");
            return (Criteria) this;
        }

        public Criteria andExpectedArrivalTimeBetween(Date value1, Date value2) {
            addCriterion("expected_arrival_time between", value1, value2, "expectedArrivalTime");
            return (Criteria) this;
        }

        public Criteria andExpectedArrivalTimeNotBetween(Date value1, Date value2) {
            addCriterion("expected_arrival_time not between", value1, value2, "expectedArrivalTime");
            return (Criteria) this;
        }

        public Criteria andRewardIsNull() {
            addCriterion("reward is null");
            return (Criteria) this;
        }

        public Criteria andRewardIsNotNull() {
            addCriterion("reward is not null");
            return (Criteria) this;
        }

        public Criteria andRewardEqualTo(String value) {
            addCriterion("reward =", value, "reward");
            return (Criteria) this;
        }

        public Criteria andRewardNotEqualTo(String value) {
            addCriterion("reward <>", value, "reward");
            return (Criteria) this;
        }

        public Criteria andRewardGreaterThan(String value) {
            addCriterion("reward >", value, "reward");
            return (Criteria) this;
        }

        public Criteria andRewardGreaterThanOrEqualTo(String value) {
            addCriterion("reward >=", value, "reward");
            return (Criteria) this;
        }

        public Criteria andRewardLessThan(String value) {
            addCriterion("reward <", value, "reward");
            return (Criteria) this;
        }

        public Criteria andRewardLessThanOrEqualTo(String value) {
            addCriterion("reward <=", value, "reward");
            return (Criteria) this;
        }

        public Criteria andRewardLike(String value) {
            addCriterion("reward like", value, "reward");
            return (Criteria) this;
        }

        public Criteria andRewardNotLike(String value) {
            addCriterion("reward not like", value, "reward");
            return (Criteria) this;
        }

        public Criteria andRewardIn(List<String> values) {
            addCriterion("reward in", values, "reward");
            return (Criteria) this;
        }

        public Criteria andRewardNotIn(List<String> values) {
            addCriterion("reward not in", values, "reward");
            return (Criteria) this;
        }

        public Criteria andRewardBetween(String value1, String value2) {
            addCriterion("reward between", value1, value2, "reward");
            return (Criteria) this;
        }

        public Criteria andRewardNotBetween(String value1, String value2) {
            addCriterion("reward not between", value1, value2, "reward");
            return (Criteria) this;
        }

        public Criteria andEstimateThePriceIsNull() {
            addCriterion("estimate_the_price is null");
            return (Criteria) this;
        }

        public Criteria andEstimateThePriceIsNotNull() {
            addCriterion("estimate_the_price is not null");
            return (Criteria) this;
        }

        public Criteria andEstimateThePriceEqualTo(String value) {
            addCriterion("estimate_the_price =", value, "estimateThePrice");
            return (Criteria) this;
        }

        public Criteria andEstimateThePriceNotEqualTo(String value) {
            addCriterion("estimate_the_price <>", value, "estimateThePrice");
            return (Criteria) this;
        }

        public Criteria andEstimateThePriceGreaterThan(String value) {
            addCriterion("estimate_the_price >", value, "estimateThePrice");
            return (Criteria) this;
        }

        public Criteria andEstimateThePriceGreaterThanOrEqualTo(String value) {
            addCriterion("estimate_the_price >=", value, "estimateThePrice");
            return (Criteria) this;
        }

        public Criteria andEstimateThePriceLessThan(String value) {
            addCriterion("estimate_the_price <", value, "estimateThePrice");
            return (Criteria) this;
        }

        public Criteria andEstimateThePriceLessThanOrEqualTo(String value) {
            addCriterion("estimate_the_price <=", value, "estimateThePrice");
            return (Criteria) this;
        }

        public Criteria andEstimateThePriceLike(String value) {
            addCriterion("estimate_the_price like", value, "estimateThePrice");
            return (Criteria) this;
        }

        public Criteria andEstimateThePriceNotLike(String value) {
            addCriterion("estimate_the_price not like", value, "estimateThePrice");
            return (Criteria) this;
        }

        public Criteria andEstimateThePriceIn(List<String> values) {
            addCriterion("estimate_the_price in", values, "estimateThePrice");
            return (Criteria) this;
        }

        public Criteria andEstimateThePriceNotIn(List<String> values) {
            addCriterion("estimate_the_price not in", values, "estimateThePrice");
            return (Criteria) this;
        }

        public Criteria andEstimateThePriceBetween(String value1, String value2) {
            addCriterion("estimate_the_price between", value1, value2, "estimateThePrice");
            return (Criteria) this;
        }

        public Criteria andEstimateThePriceNotBetween(String value1, String value2) {
            addCriterion("estimate_the_price not between", value1, value2, "estimateThePrice");
            return (Criteria) this;
        }

        public Criteria andCourierFeesIsNull() {
            addCriterion("courier_fees is null");
            return (Criteria) this;
        }

        public Criteria andCourierFeesIsNotNull() {
            addCriterion("courier_fees is not null");
            return (Criteria) this;
        }

        public Criteria andCourierFeesEqualTo(String value) {
            addCriterion("courier_fees =", value, "courierFees");
            return (Criteria) this;
        }

        public Criteria andCourierFeesNotEqualTo(String value) {
            addCriterion("courier_fees <>", value, "courierFees");
            return (Criteria) this;
        }

        public Criteria andCourierFeesGreaterThan(String value) {
            addCriterion("courier_fees >", value, "courierFees");
            return (Criteria) this;
        }

        public Criteria andCourierFeesGreaterThanOrEqualTo(String value) {
            addCriterion("courier_fees >=", value, "courierFees");
            return (Criteria) this;
        }

        public Criteria andCourierFeesLessThan(String value) {
            addCriterion("courier_fees <", value, "courierFees");
            return (Criteria) this;
        }

        public Criteria andCourierFeesLessThanOrEqualTo(String value) {
            addCriterion("courier_fees <=", value, "courierFees");
            return (Criteria) this;
        }

        public Criteria andCourierFeesLike(String value) {
            addCriterion("courier_fees like", value, "courierFees");
            return (Criteria) this;
        }

        public Criteria andCourierFeesNotLike(String value) {
            addCriterion("courier_fees not like", value, "courierFees");
            return (Criteria) this;
        }

        public Criteria andCourierFeesIn(List<String> values) {
            addCriterion("courier_fees in", values, "courierFees");
            return (Criteria) this;
        }

        public Criteria andCourierFeesNotIn(List<String> values) {
            addCriterion("courier_fees not in", values, "courierFees");
            return (Criteria) this;
        }

        public Criteria andCourierFeesBetween(String value1, String value2) {
            addCriterion("courier_fees between", value1, value2, "courierFees");
            return (Criteria) this;
        }

        public Criteria andCourierFeesNotBetween(String value1, String value2) {
            addCriterion("courier_fees not between", value1, value2, "courierFees");
            return (Criteria) this;
        }

        public Criteria andAddressIdIsNull() {
            addCriterion("address_id is null");
            return (Criteria) this;
        }

        public Criteria andAddressIdIsNotNull() {
            addCriterion("address_id is not null");
            return (Criteria) this;
        }

        public Criteria andAddressIdEqualTo(Integer value) {
            addCriterion("address_id =", value, "addressId");
            return (Criteria) this;
        }

        public Criteria andAddressIdNotEqualTo(Integer value) {
            addCriterion("address_id <>", value, "addressId");
            return (Criteria) this;
        }

        public Criteria andAddressIdGreaterThan(Integer value) {
            addCriterion("address_id >", value, "addressId");
            return (Criteria) this;
        }

        public Criteria andAddressIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("address_id >=", value, "addressId");
            return (Criteria) this;
        }

        public Criteria andAddressIdLessThan(Integer value) {
            addCriterion("address_id <", value, "addressId");
            return (Criteria) this;
        }

        public Criteria andAddressIdLessThanOrEqualTo(Integer value) {
            addCriterion("address_id <=", value, "addressId");
            return (Criteria) this;
        }

        public Criteria andAddressIdIn(List<Integer> values) {
            addCriterion("address_id in", values, "addressId");
            return (Criteria) this;
        }

        public Criteria andAddressIdNotIn(List<Integer> values) {
            addCriterion("address_id not in", values, "addressId");
            return (Criteria) this;
        }

        public Criteria andAddressIdBetween(Integer value1, Integer value2) {
            addCriterion("address_id between", value1, value2, "addressId");
            return (Criteria) this;
        }

        public Criteria andAddressIdNotBetween(Integer value1, Integer value2) {
            addCriterion("address_id not between", value1, value2, "addressId");
            return (Criteria) this;
        }

        public Criteria andDemandCreatetimeIsNull() {
            addCriterion("demand_createtime is null");
            return (Criteria) this;
        }

        public Criteria andDemandCreatetimeIsNotNull() {
            addCriterion("demand_createtime is not null");
            return (Criteria) this;
        }

        public Criteria andDemandCreatetimeEqualTo(Date value) {
            addCriterion("demand_createtime =", value, "demandCreatetime");
            return (Criteria) this;
        }

        public Criteria andDemandCreatetimeNotEqualTo(Date value) {
            addCriterion("demand_createtime <>", value, "demandCreatetime");
            return (Criteria) this;
        }

        public Criteria andDemandCreatetimeGreaterThan(Date value) {
            addCriterion("demand_createtime >", value, "demandCreatetime");
            return (Criteria) this;
        }

        public Criteria andDemandCreatetimeGreaterThanOrEqualTo(Date value) {
            addCriterion("demand_createtime >=", value, "demandCreatetime");
            return (Criteria) this;
        }

        public Criteria andDemandCreatetimeLessThan(Date value) {
            addCriterion("demand_createtime <", value, "demandCreatetime");
            return (Criteria) this;
        }

        public Criteria andDemandCreatetimeLessThanOrEqualTo(Date value) {
            addCriterion("demand_createtime <=", value, "demandCreatetime");
            return (Criteria) this;
        }

        public Criteria andDemandCreatetimeIn(List<Date> values) {
            addCriterion("demand_createtime in", values, "demandCreatetime");
            return (Criteria) this;
        }

        public Criteria andDemandCreatetimeNotIn(List<Date> values) {
            addCriterion("demand_createtime not in", values, "demandCreatetime");
            return (Criteria) this;
        }

        public Criteria andDemandCreatetimeBetween(Date value1, Date value2) {
            addCriterion("demand_createtime between", value1, value2, "demandCreatetime");
            return (Criteria) this;
        }

        public Criteria andDemandCreatetimeNotBetween(Date value1, Date value2) {
            addCriterion("demand_createtime not between", value1, value2, "demandCreatetime");
            return (Criteria) this;
        }

        public Criteria andNoteIsNull() {
            addCriterion("note is null");
            return (Criteria) this;
        }

        public Criteria andNoteIsNotNull() {
            addCriterion("note is not null");
            return (Criteria) this;
        }

        public Criteria andNoteEqualTo(String value) {
            addCriterion("note =", value, "note");
            return (Criteria) this;
        }

        public Criteria andNoteNotEqualTo(String value) {
            addCriterion("note <>", value, "note");
            return (Criteria) this;
        }

        public Criteria andNoteGreaterThan(String value) {
            addCriterion("note >", value, "note");
            return (Criteria) this;
        }

        public Criteria andNoteGreaterThanOrEqualTo(String value) {
            addCriterion("note >=", value, "note");
            return (Criteria) this;
        }

        public Criteria andNoteLessThan(String value) {
            addCriterion("note <", value, "note");
            return (Criteria) this;
        }

        public Criteria andNoteLessThanOrEqualTo(String value) {
            addCriterion("note <=", value, "note");
            return (Criteria) this;
        }

        public Criteria andNoteLike(String value) {
            addCriterion("note like", value, "note");
            return (Criteria) this;
        }

        public Criteria andNoteNotLike(String value) {
            addCriterion("note not like", value, "note");
            return (Criteria) this;
        }

        public Criteria andNoteIn(List<String> values) {
            addCriterion("note in", values, "note");
            return (Criteria) this;
        }

        public Criteria andNoteNotIn(List<String> values) {
            addCriterion("note not in", values, "note");
            return (Criteria) this;
        }

        public Criteria andNoteBetween(String value1, String value2) {
            addCriterion("note between", value1, value2, "note");
            return (Criteria) this;
        }

        public Criteria andNoteNotBetween(String value1, String value2) {
            addCriterion("note not between", value1, value2, "note");
            return (Criteria) this;
        }

        public Criteria andTradeNameIsNull() {
            addCriterion("trade_name is null");
            return (Criteria) this;
        }

        public Criteria andTradeNameIsNotNull() {
            addCriterion("trade_name is not null");
            return (Criteria) this;
        }

        public Criteria andTradeNameEqualTo(String value) {
            addCriterion("trade_name =", value, "tradeName");
            return (Criteria) this;
        }

        public Criteria andTradeNameNotEqualTo(String value) {
            addCriterion("trade_name <>", value, "tradeName");
            return (Criteria) this;
        }

        public Criteria andTradeNameGreaterThan(String value) {
            addCriterion("trade_name >", value, "tradeName");
            return (Criteria) this;
        }

        public Criteria andTradeNameGreaterThanOrEqualTo(String value) {
            addCriterion("trade_name >=", value, "tradeName");
            return (Criteria) this;
        }

        public Criteria andTradeNameLessThan(String value) {
            addCriterion("trade_name <", value, "tradeName");
            return (Criteria) this;
        }

        public Criteria andTradeNameLessThanOrEqualTo(String value) {
            addCriterion("trade_name <=", value, "tradeName");
            return (Criteria) this;
        }

        public Criteria andTradeNameLike(String value) {
            addCriterion("trade_name like", value, "tradeName");
            return (Criteria) this;
        }

        public Criteria andTradeNameNotLike(String value) {
            addCriterion("trade_name not like", value, "tradeName");
            return (Criteria) this;
        }

        public Criteria andTradeNameIn(List<String> values) {
            addCriterion("trade_name in", values, "tradeName");
            return (Criteria) this;
        }

        public Criteria andTradeNameNotIn(List<String> values) {
            addCriterion("trade_name not in", values, "tradeName");
            return (Criteria) this;
        }

        public Criteria andTradeNameBetween(String value1, String value2) {
            addCriterion("trade_name between", value1, value2, "tradeName");
            return (Criteria) this;
        }

        public Criteria andTradeNameNotBetween(String value1, String value2) {
            addCriterion("trade_name not between", value1, value2, "tradeName");
            return (Criteria) this;
        }

        public Criteria andPurchaseStoreIsNull() {
            addCriterion("purchase_store is null");
            return (Criteria) this;
        }

        public Criteria andPurchaseStoreIsNotNull() {
            addCriterion("purchase_store is not null");
            return (Criteria) this;
        }

        public Criteria andPurchaseStoreEqualTo(String value) {
            addCriterion("purchase_store =", value, "purchaseStore");
            return (Criteria) this;
        }

        public Criteria andPurchaseStoreNotEqualTo(String value) {
            addCriterion("purchase_store <>", value, "purchaseStore");
            return (Criteria) this;
        }

        public Criteria andPurchaseStoreGreaterThan(String value) {
            addCriterion("purchase_store >", value, "purchaseStore");
            return (Criteria) this;
        }

        public Criteria andPurchaseStoreGreaterThanOrEqualTo(String value) {
            addCriterion("purchase_store >=", value, "purchaseStore");
            return (Criteria) this;
        }

        public Criteria andPurchaseStoreLessThan(String value) {
            addCriterion("purchase_store <", value, "purchaseStore");
            return (Criteria) this;
        }

        public Criteria andPurchaseStoreLessThanOrEqualTo(String value) {
            addCriterion("purchase_store <=", value, "purchaseStore");
            return (Criteria) this;
        }

        public Criteria andPurchaseStoreLike(String value) {
            addCriterion("purchase_store like", value, "purchaseStore");
            return (Criteria) this;
        }

        public Criteria andPurchaseStoreNotLike(String value) {
            addCriterion("purchase_store not like", value, "purchaseStore");
            return (Criteria) this;
        }

        public Criteria andPurchaseStoreIn(List<String> values) {
            addCriterion("purchase_store in", values, "purchaseStore");
            return (Criteria) this;
        }

        public Criteria andPurchaseStoreNotIn(List<String> values) {
            addCriterion("purchase_store not in", values, "purchaseStore");
            return (Criteria) this;
        }

        public Criteria andPurchaseStoreBetween(String value1, String value2) {
            addCriterion("purchase_store between", value1, value2, "purchaseStore");
            return (Criteria) this;
        }

        public Criteria andPurchaseStoreNotBetween(String value1, String value2) {
            addCriterion("purchase_store not between", value1, value2, "purchaseStore");
            return (Criteria) this;
        }

        public Criteria andPurchasePlaceIsNull() {
            addCriterion("purchase_place is null");
            return (Criteria) this;
        }

        public Criteria andPurchasePlaceIsNotNull() {
            addCriterion("purchase_place is not null");
            return (Criteria) this;
        }

        public Criteria andPurchasePlaceEqualTo(String value) {
            addCriterion("purchase_place =", value, "purchasePlace");
            return (Criteria) this;
        }

        public Criteria andPurchasePlaceNotEqualTo(String value) {
            addCriterion("purchase_place <>", value, "purchasePlace");
            return (Criteria) this;
        }

        public Criteria andPurchasePlaceGreaterThan(String value) {
            addCriterion("purchase_place >", value, "purchasePlace");
            return (Criteria) this;
        }

        public Criteria andPurchasePlaceGreaterThanOrEqualTo(String value) {
            addCriterion("purchase_place >=", value, "purchasePlace");
            return (Criteria) this;
        }

        public Criteria andPurchasePlaceLessThan(String value) {
            addCriterion("purchase_place <", value, "purchasePlace");
            return (Criteria) this;
        }

        public Criteria andPurchasePlaceLessThanOrEqualTo(String value) {
            addCriterion("purchase_place <=", value, "purchasePlace");
            return (Criteria) this;
        }

        public Criteria andPurchasePlaceLike(String value) {
            addCriterion("purchase_place like", value, "purchasePlace");
            return (Criteria) this;
        }

        public Criteria andPurchasePlaceNotLike(String value) {
            addCriterion("purchase_place not like", value, "purchasePlace");
            return (Criteria) this;
        }

        public Criteria andPurchasePlaceIn(List<String> values) {
            addCriterion("purchase_place in", values, "purchasePlace");
            return (Criteria) this;
        }

        public Criteria andPurchasePlaceNotIn(List<String> values) {
            addCriterion("purchase_place not in", values, "purchasePlace");
            return (Criteria) this;
        }

        public Criteria andPurchasePlaceBetween(String value1, String value2) {
            addCriterion("purchase_place between", value1, value2, "purchasePlace");
            return (Criteria) this;
        }

        public Criteria andPurchasePlaceNotBetween(String value1, String value2) {
            addCriterion("purchase_place not between", value1, value2, "purchasePlace");
            return (Criteria) this;
        }

        public Criteria andDemandStateIsNull() {
            addCriterion("demand_state is null");
            return (Criteria) this;
        }

        public Criteria andDemandStateIsNotNull() {
            addCriterion("demand_state is not null");
            return (Criteria) this;
        }

        public Criteria andDemandStateEqualTo(Integer value) {
            addCriterion("demand_state =", value, "demandState");
            return (Criteria) this;
        }

        public Criteria andDemandStateNotEqualTo(Integer value) {
            addCriterion("demand_state <>", value, "demandState");
            return (Criteria) this;
        }

        public Criteria andDemandStateGreaterThan(Integer value) {
            addCriterion("demand_state >", value, "demandState");
            return (Criteria) this;
        }

        public Criteria andDemandStateGreaterThanOrEqualTo(Integer value) {
            addCriterion("demand_state >=", value, "demandState");
            return (Criteria) this;
        }

        public Criteria andDemandStateLessThan(Integer value) {
            addCriterion("demand_state <", value, "demandState");
            return (Criteria) this;
        }

        public Criteria andDemandStateLessThanOrEqualTo(Integer value) {
            addCriterion("demand_state <=", value, "demandState");
            return (Criteria) this;
        }

        public Criteria andDemandStateIn(List<Integer> values) {
            addCriterion("demand_state in", values, "demandState");
            return (Criteria) this;
        }

        public Criteria andDemandStateNotIn(List<Integer> values) {
            addCriterion("demand_state not in", values, "demandState");
            return (Criteria) this;
        }

        public Criteria andDemandStateBetween(Integer value1, Integer value2) {
            addCriterion("demand_state between", value1, value2, "demandState");
            return (Criteria) this;
        }

        public Criteria andDemandStateNotBetween(Integer value1, Integer value2) {
            addCriterion("demand_state not between", value1, value2, "demandState");
            return (Criteria) this;
        }

        public Criteria andNicknameIsNull() {
            addCriterion("nickname is null");
            return (Criteria) this;
        }

        public Criteria andNicknameIsNotNull() {
            addCriterion("nickname is not null");
            return (Criteria) this;
        }

        public Criteria andNicknameEqualTo(String value) {
            addCriterion("nickname =", value, "nickname");
            return (Criteria) this;
        }

        public Criteria andNicknameNotEqualTo(String value) {
            addCriterion("nickname <>", value, "nickname");
            return (Criteria) this;
        }

        public Criteria andNicknameGreaterThan(String value) {
            addCriterion("nickname >", value, "nickname");
            return (Criteria) this;
        }

        public Criteria andNicknameGreaterThanOrEqualTo(String value) {
            addCriterion("nickname >=", value, "nickname");
            return (Criteria) this;
        }

        public Criteria andNicknameLessThan(String value) {
            addCriterion("nickname <", value, "nickname");
            return (Criteria) this;
        }

        public Criteria andNicknameLessThanOrEqualTo(String value) {
            addCriterion("nickname <=", value, "nickname");
            return (Criteria) this;
        }

        public Criteria andNicknameLike(String value) {
            addCriterion("nickname like", value, "nickname");
            return (Criteria) this;
        }

        public Criteria andNicknameNotLike(String value) {
            addCriterion("nickname not like", value, "nickname");
            return (Criteria) this;
        }

        public Criteria andNicknameIn(List<String> values) {
            addCriterion("nickname in", values, "nickname");
            return (Criteria) this;
        }

        public Criteria andNicknameNotIn(List<String> values) {
            addCriterion("nickname not in", values, "nickname");
            return (Criteria) this;
        }

        public Criteria andNicknameBetween(String value1, String value2) {
            addCriterion("nickname between", value1, value2, "nickname");
            return (Criteria) this;
        }

        public Criteria andNicknameNotBetween(String value1, String value2) {
            addCriterion("nickname not between", value1, value2, "nickname");
            return (Criteria) this;
        }

        public Criteria andSexIsNull() {
            addCriterion("sex is null");
            return (Criteria) this;
        }

        public Criteria andSexIsNotNull() {
            addCriterion("sex is not null");
            return (Criteria) this;
        }

        public Criteria andSexEqualTo(String value) {
            addCriterion("sex =", value, "sex");
            return (Criteria) this;
        }

        public Criteria andSexNotEqualTo(String value) {
            addCriterion("sex <>", value, "sex");
            return (Criteria) this;
        }

        public Criteria andSexGreaterThan(String value) {
            addCriterion("sex >", value, "sex");
            return (Criteria) this;
        }

        public Criteria andSexGreaterThanOrEqualTo(String value) {
            addCriterion("sex >=", value, "sex");
            return (Criteria) this;
        }

        public Criteria andSexLessThan(String value) {
            addCriterion("sex <", value, "sex");
            return (Criteria) this;
        }

        public Criteria andSexLessThanOrEqualTo(String value) {
            addCriterion("sex <=", value, "sex");
            return (Criteria) this;
        }

        public Criteria andSexLike(String value) {
            addCriterion("sex like", value, "sex");
            return (Criteria) this;
        }

        public Criteria andSexNotLike(String value) {
            addCriterion("sex not like", value, "sex");
            return (Criteria) this;
        }

        public Criteria andSexIn(List<String> values) {
            addCriterion("sex in", values, "sex");
            return (Criteria) this;
        }

        public Criteria andSexNotIn(List<String> values) {
            addCriterion("sex not in", values, "sex");
            return (Criteria) this;
        }

        public Criteria andSexBetween(String value1, String value2) {
            addCriterion("sex between", value1, value2, "sex");
            return (Criteria) this;
        }

        public Criteria andSexNotBetween(String value1, String value2) {
            addCriterion("sex not between", value1, value2, "sex");
            return (Criteria) this;
        }

        public Criteria andBirthdayIsNull() {
            addCriterion("birthday is null");
            return (Criteria) this;
        }

        public Criteria andBirthdayIsNotNull() {
            addCriterion("birthday is not null");
            return (Criteria) this;
        }

        public Criteria andBirthdayEqualTo(Date value) {
            addCriterionForJDBCDate("birthday =", value, "birthday");
            return (Criteria) this;
        }

        public Criteria andBirthdayNotEqualTo(Date value) {
            addCriterionForJDBCDate("birthday <>", value, "birthday");
            return (Criteria) this;
        }

        public Criteria andBirthdayGreaterThan(Date value) {
            addCriterionForJDBCDate("birthday >", value, "birthday");
            return (Criteria) this;
        }

        public Criteria andBirthdayGreaterThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("birthday >=", value, "birthday");
            return (Criteria) this;
        }

        public Criteria andBirthdayLessThan(Date value) {
            addCriterionForJDBCDate("birthday <", value, "birthday");
            return (Criteria) this;
        }

        public Criteria andBirthdayLessThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("birthday <=", value, "birthday");
            return (Criteria) this;
        }

        public Criteria andBirthdayIn(List<Date> values) {
            addCriterionForJDBCDate("birthday in", values, "birthday");
            return (Criteria) this;
        }

        public Criteria andBirthdayNotIn(List<Date> values) {
            addCriterionForJDBCDate("birthday not in", values, "birthday");
            return (Criteria) this;
        }

        public Criteria andBirthdayBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("birthday between", value1, value2, "birthday");
            return (Criteria) this;
        }

        public Criteria andBirthdayNotBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("birthday not between", value1, value2, "birthday");
            return (Criteria) this;
        }

        public Criteria andRegionIsNull() {
            addCriterion("region is null");
            return (Criteria) this;
        }

        public Criteria andRegionIsNotNull() {
            addCriterion("region is not null");
            return (Criteria) this;
        }

        public Criteria andRegionEqualTo(String value) {
            addCriterion("region =", value, "region");
            return (Criteria) this;
        }

        public Criteria andRegionNotEqualTo(String value) {
            addCriterion("region <>", value, "region");
            return (Criteria) this;
        }

        public Criteria andRegionGreaterThan(String value) {
            addCriterion("region >", value, "region");
            return (Criteria) this;
        }

        public Criteria andRegionGreaterThanOrEqualTo(String value) {
            addCriterion("region >=", value, "region");
            return (Criteria) this;
        }

        public Criteria andRegionLessThan(String value) {
            addCriterion("region <", value, "region");
            return (Criteria) this;
        }

        public Criteria andRegionLessThanOrEqualTo(String value) {
            addCriterion("region <=", value, "region");
            return (Criteria) this;
        }

        public Criteria andRegionLike(String value) {
            addCriterion("region like", value, "region");
            return (Criteria) this;
        }

        public Criteria andRegionNotLike(String value) {
            addCriterion("region not like", value, "region");
            return (Criteria) this;
        }

        public Criteria andRegionIn(List<String> values) {
            addCriterion("region in", values, "region");
            return (Criteria) this;
        }

        public Criteria andRegionNotIn(List<String> values) {
            addCriterion("region not in", values, "region");
            return (Criteria) this;
        }

        public Criteria andRegionBetween(String value1, String value2) {
            addCriterion("region between", value1, value2, "region");
            return (Criteria) this;
        }

        public Criteria andRegionNotBetween(String value1, String value2) {
            addCriterion("region not between", value1, value2, "region");
            return (Criteria) this;
        }

        public Criteria andSignatureIsNull() {
            addCriterion("signature is null");
            return (Criteria) this;
        }

        public Criteria andSignatureIsNotNull() {
            addCriterion("signature is not null");
            return (Criteria) this;
        }

        public Criteria andSignatureEqualTo(String value) {
            addCriterion("signature =", value, "signature");
            return (Criteria) this;
        }

        public Criteria andSignatureNotEqualTo(String value) {
            addCriterion("signature <>", value, "signature");
            return (Criteria) this;
        }

        public Criteria andSignatureGreaterThan(String value) {
            addCriterion("signature >", value, "signature");
            return (Criteria) this;
        }

        public Criteria andSignatureGreaterThanOrEqualTo(String value) {
            addCriterion("signature >=", value, "signature");
            return (Criteria) this;
        }

        public Criteria andSignatureLessThan(String value) {
            addCriterion("signature <", value, "signature");
            return (Criteria) this;
        }

        public Criteria andSignatureLessThanOrEqualTo(String value) {
            addCriterion("signature <=", value, "signature");
            return (Criteria) this;
        }

        public Criteria andSignatureLike(String value) {
            addCriterion("signature like", value, "signature");
            return (Criteria) this;
        }

        public Criteria andSignatureNotLike(String value) {
            addCriterion("signature not like", value, "signature");
            return (Criteria) this;
        }

        public Criteria andSignatureIn(List<String> values) {
            addCriterion("signature in", values, "signature");
            return (Criteria) this;
        }

        public Criteria andSignatureNotIn(List<String> values) {
            addCriterion("signature not in", values, "signature");
            return (Criteria) this;
        }

        public Criteria andSignatureBetween(String value1, String value2) {
            addCriterion("signature between", value1, value2, "signature");
            return (Criteria) this;
        }

        public Criteria andSignatureNotBetween(String value1, String value2) {
            addCriterion("signature not between", value1, value2, "signature");
            return (Criteria) this;
        }

        public Criteria andHeadPortraitUrlIsNull() {
            addCriterion("head_portrait_url is null");
            return (Criteria) this;
        }

        public Criteria andHeadPortraitUrlIsNotNull() {
            addCriterion("head_portrait_url is not null");
            return (Criteria) this;
        }

        public Criteria andHeadPortraitUrlEqualTo(String value) {
            addCriterion("head_portrait_url =", value, "headPortraitUrl");
            return (Criteria) this;
        }

        public Criteria andHeadPortraitUrlNotEqualTo(String value) {
            addCriterion("head_portrait_url <>", value, "headPortraitUrl");
            return (Criteria) this;
        }

        public Criteria andHeadPortraitUrlGreaterThan(String value) {
            addCriterion("head_portrait_url >", value, "headPortraitUrl");
            return (Criteria) this;
        }

        public Criteria andHeadPortraitUrlGreaterThanOrEqualTo(String value) {
            addCriterion("head_portrait_url >=", value, "headPortraitUrl");
            return (Criteria) this;
        }

        public Criteria andHeadPortraitUrlLessThan(String value) {
            addCriterion("head_portrait_url <", value, "headPortraitUrl");
            return (Criteria) this;
        }

        public Criteria andHeadPortraitUrlLessThanOrEqualTo(String value) {
            addCriterion("head_portrait_url <=", value, "headPortraitUrl");
            return (Criteria) this;
        }

        public Criteria andHeadPortraitUrlLike(String value) {
            addCriterion("head_portrait_url like", value, "headPortraitUrl");
            return (Criteria) this;
        }

        public Criteria andHeadPortraitUrlNotLike(String value) {
            addCriterion("head_portrait_url not like", value, "headPortraitUrl");
            return (Criteria) this;
        }

        public Criteria andHeadPortraitUrlIn(List<String> values) {
            addCriterion("head_portrait_url in", values, "headPortraitUrl");
            return (Criteria) this;
        }

        public Criteria andHeadPortraitUrlNotIn(List<String> values) {
            addCriterion("head_portrait_url not in", values, "headPortraitUrl");
            return (Criteria) this;
        }

        public Criteria andHeadPortraitUrlBetween(String value1, String value2) {
            addCriterion("head_portrait_url between", value1, value2, "headPortraitUrl");
            return (Criteria) this;
        }

        public Criteria andHeadPortraitUrlNotBetween(String value1, String value2) {
            addCriterion("head_portrait_url not between", value1, value2, "headPortraitUrl");
            return (Criteria) this;
        }

        public Criteria andPermissionsIsNull() {
            addCriterion("permissions is null");
            return (Criteria) this;
        }

        public Criteria andPermissionsIsNotNull() {
            addCriterion("permissions is not null");
            return (Criteria) this;
        }

        public Criteria andPermissionsEqualTo(Integer value) {
            addCriterion("permissions =", value, "permissions");
            return (Criteria) this;
        }

        public Criteria andPermissionsNotEqualTo(Integer value) {
            addCriterion("permissions <>", value, "permissions");
            return (Criteria) this;
        }

        public Criteria andPermissionsGreaterThan(Integer value) {
            addCriterion("permissions >", value, "permissions");
            return (Criteria) this;
        }

        public Criteria andPermissionsGreaterThanOrEqualTo(Integer value) {
            addCriterion("permissions >=", value, "permissions");
            return (Criteria) this;
        }

        public Criteria andPermissionsLessThan(Integer value) {
            addCriterion("permissions <", value, "permissions");
            return (Criteria) this;
        }

        public Criteria andPermissionsLessThanOrEqualTo(Integer value) {
            addCriterion("permissions <=", value, "permissions");
            return (Criteria) this;
        }

        public Criteria andPermissionsIn(List<Integer> values) {
            addCriterion("permissions in", values, "permissions");
            return (Criteria) this;
        }

        public Criteria andPermissionsNotIn(List<Integer> values) {
            addCriterion("permissions not in", values, "permissions");
            return (Criteria) this;
        }

        public Criteria andPermissionsBetween(Integer value1, Integer value2) {
            addCriterion("permissions between", value1, value2, "permissions");
            return (Criteria) this;
        }

        public Criteria andPermissionsNotBetween(Integer value1, Integer value2) {
            addCriterion("permissions not between", value1, value2, "permissions");
            return (Criteria) this;
        }

        public Criteria andLastLoginTimeIsNull() {
            addCriterion("last_login_time is null");
            return (Criteria) this;
        }

        public Criteria andLastLoginTimeIsNotNull() {
            addCriterion("last_login_time is not null");
            return (Criteria) this;
        }

        public Criteria andLastLoginTimeEqualTo(Date value) {
            addCriterion("last_login_time =", value, "lastLoginTime");
            return (Criteria) this;
        }

        public Criteria andLastLoginTimeNotEqualTo(Date value) {
            addCriterion("last_login_time <>", value, "lastLoginTime");
            return (Criteria) this;
        }

        public Criteria andLastLoginTimeGreaterThan(Date value) {
            addCriterion("last_login_time >", value, "lastLoginTime");
            return (Criteria) this;
        }

        public Criteria andLastLoginTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("last_login_time >=", value, "lastLoginTime");
            return (Criteria) this;
        }

        public Criteria andLastLoginTimeLessThan(Date value) {
            addCriterion("last_login_time <", value, "lastLoginTime");
            return (Criteria) this;
        }

        public Criteria andLastLoginTimeLessThanOrEqualTo(Date value) {
            addCriterion("last_login_time <=", value, "lastLoginTime");
            return (Criteria) this;
        }

        public Criteria andLastLoginTimeIn(List<Date> values) {
            addCriterion("last_login_time in", values, "lastLoginTime");
            return (Criteria) this;
        }

        public Criteria andLastLoginTimeNotIn(List<Date> values) {
            addCriterion("last_login_time not in", values, "lastLoginTime");
            return (Criteria) this;
        }

        public Criteria andLastLoginTimeBetween(Date value1, Date value2) {
            addCriterion("last_login_time between", value1, value2, "lastLoginTime");
            return (Criteria) this;
        }

        public Criteria andLastLoginTimeNotBetween(Date value1, Date value2) {
            addCriterion("last_login_time not between", value1, value2, "lastLoginTime");
            return (Criteria) this;
        }

        public Criteria andAddressIsNull() {
            addCriterion("address is null");
            return (Criteria) this;
        }

        public Criteria andAddressIsNotNull() {
            addCriterion("address is not null");
            return (Criteria) this;
        }

        public Criteria andAddressEqualTo(String value) {
            addCriterion("address =", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotEqualTo(String value) {
            addCriterion("address <>", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressGreaterThan(String value) {
            addCriterion("address >", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressGreaterThanOrEqualTo(String value) {
            addCriterion("address >=", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressLessThan(String value) {
            addCriterion("address <", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressLessThanOrEqualTo(String value) {
            addCriterion("address <=", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressLike(String value) {
            addCriterion("address like", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotLike(String value) {
            addCriterion("address not like", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressIn(List<String> values) {
            addCriterion("address in", values, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotIn(List<String> values) {
            addCriterion("address not in", values, "address");
            return (Criteria) this;
        }

        public Criteria andAddressBetween(String value1, String value2) {
            addCriterion("address between", value1, value2, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotBetween(String value1, String value2) {
            addCriterion("address not between", value1, value2, "address");
            return (Criteria) this;
        }

        public Criteria andContactsIsNull() {
            addCriterion("contacts is null");
            return (Criteria) this;
        }

        public Criteria andContactsIsNotNull() {
            addCriterion("contacts is not null");
            return (Criteria) this;
        }

        public Criteria andContactsEqualTo(String value) {
            addCriterion("contacts =", value, "contacts");
            return (Criteria) this;
        }

        public Criteria andContactsNotEqualTo(String value) {
            addCriterion("contacts <>", value, "contacts");
            return (Criteria) this;
        }

        public Criteria andContactsGreaterThan(String value) {
            addCriterion("contacts >", value, "contacts");
            return (Criteria) this;
        }

        public Criteria andContactsGreaterThanOrEqualTo(String value) {
            addCriterion("contacts >=", value, "contacts");
            return (Criteria) this;
        }

        public Criteria andContactsLessThan(String value) {
            addCriterion("contacts <", value, "contacts");
            return (Criteria) this;
        }

        public Criteria andContactsLessThanOrEqualTo(String value) {
            addCriterion("contacts <=", value, "contacts");
            return (Criteria) this;
        }

        public Criteria andContactsLike(String value) {
            addCriterion("contacts like", value, "contacts");
            return (Criteria) this;
        }

        public Criteria andContactsNotLike(String value) {
            addCriterion("contacts not like", value, "contacts");
            return (Criteria) this;
        }

        public Criteria andContactsIn(List<String> values) {
            addCriterion("contacts in", values, "contacts");
            return (Criteria) this;
        }

        public Criteria andContactsNotIn(List<String> values) {
            addCriterion("contacts not in", values, "contacts");
            return (Criteria) this;
        }

        public Criteria andContactsBetween(String value1, String value2) {
            addCriterion("contacts between", value1, value2, "contacts");
            return (Criteria) this;
        }

        public Criteria andContactsNotBetween(String value1, String value2) {
            addCriterion("contacts not between", value1, value2, "contacts");
            return (Criteria) this;
        }

        public Criteria andIntegralScoreIsNull() {
            addCriterion("integral_score is null");
            return (Criteria) this;
        }

        public Criteria andIntegralScoreIsNotNull() {
            addCriterion("integral_score is not null");
            return (Criteria) this;
        }

        public Criteria andIntegralScoreEqualTo(Integer value) {
            addCriterion("integral_score =", value, "integralScore");
            return (Criteria) this;
        }

        public Criteria andIntegralScoreNotEqualTo(Integer value) {
            addCriterion("integral_score <>", value, "integralScore");
            return (Criteria) this;
        }

        public Criteria andIntegralScoreGreaterThan(Integer value) {
            addCriterion("integral_score >", value, "integralScore");
            return (Criteria) this;
        }

        public Criteria andIntegralScoreGreaterThanOrEqualTo(Integer value) {
            addCriterion("integral_score >=", value, "integralScore");
            return (Criteria) this;
        }

        public Criteria andIntegralScoreLessThan(Integer value) {
            addCriterion("integral_score <", value, "integralScore");
            return (Criteria) this;
        }

        public Criteria andIntegralScoreLessThanOrEqualTo(Integer value) {
            addCriterion("integral_score <=", value, "integralScore");
            return (Criteria) this;
        }

        public Criteria andIntegralScoreIn(List<Integer> values) {
            addCriterion("integral_score in", values, "integralScore");
            return (Criteria) this;
        }

        public Criteria andIntegralScoreNotIn(List<Integer> values) {
            addCriterion("integral_score not in", values, "integralScore");
            return (Criteria) this;
        }

        public Criteria andIntegralScoreBetween(Integer value1, Integer value2) {
            addCriterion("integral_score between", value1, value2, "integralScore");
            return (Criteria) this;
        }

        public Criteria andIntegralScoreNotBetween(Integer value1, Integer value2) {
            addCriterion("integral_score not between", value1, value2, "integralScore");
            return (Criteria) this;
        }

        public Criteria andCreditScoreIsNull() {
            addCriterion("credit_score is null");
            return (Criteria) this;
        }

        public Criteria andCreditScoreIsNotNull() {
            addCriterion("credit_score is not null");
            return (Criteria) this;
        }

        public Criteria andCreditScoreEqualTo(Integer value) {
            addCriterion("credit_score =", value, "creditScore");
            return (Criteria) this;
        }

        public Criteria andCreditScoreNotEqualTo(Integer value) {
            addCriterion("credit_score <>", value, "creditScore");
            return (Criteria) this;
        }

        public Criteria andCreditScoreGreaterThan(Integer value) {
            addCriterion("credit_score >", value, "creditScore");
            return (Criteria) this;
        }

        public Criteria andCreditScoreGreaterThanOrEqualTo(Integer value) {
            addCriterion("credit_score >=", value, "creditScore");
            return (Criteria) this;
        }

        public Criteria andCreditScoreLessThan(Integer value) {
            addCriterion("credit_score <", value, "creditScore");
            return (Criteria) this;
        }

        public Criteria andCreditScoreLessThanOrEqualTo(Integer value) {
            addCriterion("credit_score <=", value, "creditScore");
            return (Criteria) this;
        }

        public Criteria andCreditScoreIn(List<Integer> values) {
            addCriterion("credit_score in", values, "creditScore");
            return (Criteria) this;
        }

        public Criteria andCreditScoreNotIn(List<Integer> values) {
            addCriterion("credit_score not in", values, "creditScore");
            return (Criteria) this;
        }

        public Criteria andCreditScoreBetween(Integer value1, Integer value2) {
            addCriterion("credit_score between", value1, value2, "creditScore");
            return (Criteria) this;
        }

        public Criteria andCreditScoreNotBetween(Integer value1, Integer value2) {
            addCriterion("credit_score not between", value1, value2, "creditScore");
            return (Criteria) this;
        }

        public Criteria andOrderIdIsNull() {
            addCriterion("order_id is null");
            return (Criteria) this;
        }

        public Criteria andOrderIdIsNotNull() {
            addCriterion("order_id is not null");
            return (Criteria) this;
        }

        public Criteria andOrderIdEqualTo(Integer value) {
            addCriterion("order_id =", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdNotEqualTo(Integer value) {
            addCriterion("order_id <>", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdGreaterThan(Integer value) {
            addCriterion("order_id >", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("order_id >=", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdLessThan(Integer value) {
            addCriterion("order_id <", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdLessThanOrEqualTo(Integer value) {
            addCriterion("order_id <=", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdIn(List<Integer> values) {
            addCriterion("order_id in", values, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdNotIn(List<Integer> values) {
            addCriterion("order_id not in", values, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdBetween(Integer value1, Integer value2) {
            addCriterion("order_id between", value1, value2, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdNotBetween(Integer value1, Integer value2) {
            addCriterion("order_id not between", value1, value2, "orderId");
            return (Criteria) this;
        }

        public Criteria andDemandIdIsNull() {
            addCriterion("demand_id is null");
            return (Criteria) this;
        }

        public Criteria andDemandIdIsNotNull() {
            addCriterion("demand_id is not null");
            return (Criteria) this;
        }

        public Criteria andDemandIdEqualTo(Integer value) {
            addCriterion("demand_id =", value, "demandId");
            return (Criteria) this;
        }

        public Criteria andDemandIdNotEqualTo(Integer value) {
            addCriterion("demand_id <>", value, "demandId");
            return (Criteria) this;
        }

        public Criteria andDemandIdGreaterThan(Integer value) {
            addCriterion("demand_id >", value, "demandId");
            return (Criteria) this;
        }

        public Criteria andDemandIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("demand_id >=", value, "demandId");
            return (Criteria) this;
        }

        public Criteria andDemandIdLessThan(Integer value) {
            addCriterion("demand_id <", value, "demandId");
            return (Criteria) this;
        }

        public Criteria andDemandIdLessThanOrEqualTo(Integer value) {
            addCriterion("demand_id <=", value, "demandId");
            return (Criteria) this;
        }

        public Criteria andDemandIdIn(List<Integer> values) {
            addCriterion("demand_id in", values, "demandId");
            return (Criteria) this;
        }

        public Criteria andDemandIdNotIn(List<Integer> values) {
            addCriterion("demand_id not in", values, "demandId");
            return (Criteria) this;
        }

        public Criteria andDemandIdBetween(Integer value1, Integer value2) {
            addCriterion("demand_id between", value1, value2, "demandId");
            return (Criteria) this;
        }

        public Criteria andDemandIdNotBetween(Integer value1, Integer value2) {
            addCriterion("demand_id not between", value1, value2, "demandId");
            return (Criteria) this;
        }

        public Criteria andPurchaseIdIsNull() {
            addCriterion("purchase_id is null");
            return (Criteria) this;
        }

        public Criteria andPurchaseIdIsNotNull() {
            addCriterion("purchase_id is not null");
            return (Criteria) this;
        }

        public Criteria andPurchaseIdEqualTo(Integer value) {
            addCriterion("purchase_id =", value, "purchaseId");
            return (Criteria) this;
        }

        public Criteria andPurchaseIdNotEqualTo(Integer value) {
            addCriterion("purchase_id <>", value, "purchaseId");
            return (Criteria) this;
        }

        public Criteria andPurchaseIdGreaterThan(Integer value) {
            addCriterion("purchase_id >", value, "purchaseId");
            return (Criteria) this;
        }

        public Criteria andPurchaseIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("purchase_id >=", value, "purchaseId");
            return (Criteria) this;
        }

        public Criteria andPurchaseIdLessThan(Integer value) {
            addCriterion("purchase_id <", value, "purchaseId");
            return (Criteria) this;
        }

        public Criteria andPurchaseIdLessThanOrEqualTo(Integer value) {
            addCriterion("purchase_id <=", value, "purchaseId");
            return (Criteria) this;
        }

        public Criteria andPurchaseIdIn(List<Integer> values) {
            addCriterion("purchase_id in", values, "purchaseId");
            return (Criteria) this;
        }

        public Criteria andPurchaseIdNotIn(List<Integer> values) {
            addCriterion("purchase_id not in", values, "purchaseId");
            return (Criteria) this;
        }

        public Criteria andPurchaseIdBetween(Integer value1, Integer value2) {
            addCriterion("purchase_id between", value1, value2, "purchaseId");
            return (Criteria) this;
        }

        public Criteria andPurchaseIdNotBetween(Integer value1, Integer value2) {
            addCriterion("purchase_id not between", value1, value2, "purchaseId");
            return (Criteria) this;
        }

        public Criteria andOrderStateIsNull() {
            addCriterion("order_state is null");
            return (Criteria) this;
        }

        public Criteria andOrderStateIsNotNull() {
            addCriterion("order_state is not null");
            return (Criteria) this;
        }

        public Criteria andOrderStateEqualTo(Integer value) {
            addCriterion("order_state =", value, "orderState");
            return (Criteria) this;
        }

        public Criteria andOrderStateNotEqualTo(Integer value) {
            addCriterion("order_state <>", value, "orderState");
            return (Criteria) this;
        }

        public Criteria andOrderStateGreaterThan(Integer value) {
            addCriterion("order_state >", value, "orderState");
            return (Criteria) this;
        }

        public Criteria andOrderStateGreaterThanOrEqualTo(Integer value) {
            addCriterion("order_state >=", value, "orderState");
            return (Criteria) this;
        }

        public Criteria andOrderStateLessThan(Integer value) {
            addCriterion("order_state <", value, "orderState");
            return (Criteria) this;
        }

        public Criteria andOrderStateLessThanOrEqualTo(Integer value) {
            addCriterion("order_state <=", value, "orderState");
            return (Criteria) this;
        }

        public Criteria andOrderStateIn(List<Integer> values) {
            addCriterion("order_state in", values, "orderState");
            return (Criteria) this;
        }

        public Criteria andOrderStateNotIn(List<Integer> values) {
            addCriterion("order_state not in", values, "orderState");
            return (Criteria) this;
        }

        public Criteria andOrderStateBetween(Integer value1, Integer value2) {
            addCriterion("order_state between", value1, value2, "orderState");
            return (Criteria) this;
        }

        public Criteria andOrderStateNotBetween(Integer value1, Integer value2) {
            addCriterion("order_state not between", value1, value2, "orderState");
            return (Criteria) this;
        }

        public Criteria andPurchaseUserIdIsNull() {
            addCriterion("purchase_user_id is null");
            return (Criteria) this;
        }

        public Criteria andPurchaseUserIdIsNotNull() {
            addCriterion("purchase_user_id is not null");
            return (Criteria) this;
        }

        public Criteria andPurchaseUserIdEqualTo(Integer value) {
            addCriterion("purchase_user_id =", value, "purchaseUserId");
            return (Criteria) this;
        }

        public Criteria andPurchaseUserIdNotEqualTo(Integer value) {
            addCriterion("purchase_user_id <>", value, "purchaseUserId");
            return (Criteria) this;
        }

        public Criteria andPurchaseUserIdGreaterThan(Integer value) {
            addCriterion("purchase_user_id >", value, "purchaseUserId");
            return (Criteria) this;
        }

        public Criteria andPurchaseUserIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("purchase_user_id >=", value, "purchaseUserId");
            return (Criteria) this;
        }

        public Criteria andPurchaseUserIdLessThan(Integer value) {
            addCriterion("purchase_user_id <", value, "purchaseUserId");
            return (Criteria) this;
        }

        public Criteria andPurchaseUserIdLessThanOrEqualTo(Integer value) {
            addCriterion("purchase_user_id <=", value, "purchaseUserId");
            return (Criteria) this;
        }

        public Criteria andPurchaseUserIdIn(List<Integer> values) {
            addCriterion("purchase_user_id in", values, "purchaseUserId");
            return (Criteria) this;
        }

        public Criteria andPurchaseUserIdNotIn(List<Integer> values) {
            addCriterion("purchase_user_id not in", values, "purchaseUserId");
            return (Criteria) this;
        }

        public Criteria andPurchaseUserIdBetween(Integer value1, Integer value2) {
            addCriterion("purchase_user_id between", value1, value2, "purchaseUserId");
            return (Criteria) this;
        }

        public Criteria andPurchaseUserIdNotBetween(Integer value1, Integer value2) {
            addCriterion("purchase_user_id not between", value1, value2, "purchaseUserId");
            return (Criteria) this;
        }

        public Criteria andAcceptTimeIsNull() {
            addCriterion("accept_time is null");
            return (Criteria) this;
        }

        public Criteria andAcceptTimeIsNotNull() {
            addCriterion("accept_time is not null");
            return (Criteria) this;
        }

        public Criteria andAcceptTimeEqualTo(Date value) {
            addCriterion("accept_time =", value, "acceptTime");
            return (Criteria) this;
        }

        public Criteria andAcceptTimeNotEqualTo(Date value) {
            addCriterion("accept_time <>", value, "acceptTime");
            return (Criteria) this;
        }

        public Criteria andAcceptTimeGreaterThan(Date value) {
            addCriterion("accept_time >", value, "acceptTime");
            return (Criteria) this;
        }

        public Criteria andAcceptTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("accept_time >=", value, "acceptTime");
            return (Criteria) this;
        }

        public Criteria andAcceptTimeLessThan(Date value) {
            addCriterion("accept_time <", value, "acceptTime");
            return (Criteria) this;
        }

        public Criteria andAcceptTimeLessThanOrEqualTo(Date value) {
            addCriterion("accept_time <=", value, "acceptTime");
            return (Criteria) this;
        }

        public Criteria andAcceptTimeIn(List<Date> values) {
            addCriterion("accept_time in", values, "acceptTime");
            return (Criteria) this;
        }

        public Criteria andAcceptTimeNotIn(List<Date> values) {
            addCriterion("accept_time not in", values, "acceptTime");
            return (Criteria) this;
        }

        public Criteria andAcceptTimeBetween(Date value1, Date value2) {
            addCriterion("accept_time between", value1, value2, "acceptTime");
            return (Criteria) this;
        }

        public Criteria andAcceptTimeNotBetween(Date value1, Date value2) {
            addCriterion("accept_time not between", value1, value2, "acceptTime");
            return (Criteria) this;
        }

        public Criteria andTrueMoneyIsNull() {
            addCriterion("true_money is null");
            return (Criteria) this;
        }

        public Criteria andTrueMoneyIsNotNull() {
            addCriterion("true_money is not null");
            return (Criteria) this;
        }

        public Criteria andTrueMoneyEqualTo(String value) {
            addCriterion("true_money =", value, "trueMoney");
            return (Criteria) this;
        }

        public Criteria andTrueMoneyNotEqualTo(String value) {
            addCriterion("true_money <>", value, "trueMoney");
            return (Criteria) this;
        }

        public Criteria andTrueMoneyGreaterThan(String value) {
            addCriterion("true_money >", value, "trueMoney");
            return (Criteria) this;
        }

        public Criteria andTrueMoneyGreaterThanOrEqualTo(String value) {
            addCriterion("true_money >=", value, "trueMoney");
            return (Criteria) this;
        }

        public Criteria andTrueMoneyLessThan(String value) {
            addCriterion("true_money <", value, "trueMoney");
            return (Criteria) this;
        }

        public Criteria andTrueMoneyLessThanOrEqualTo(String value) {
            addCriterion("true_money <=", value, "trueMoney");
            return (Criteria) this;
        }

        public Criteria andTrueMoneyLike(String value) {
            addCriterion("true_money like", value, "trueMoney");
            return (Criteria) this;
        }

        public Criteria andTrueMoneyNotLike(String value) {
            addCriterion("true_money not like", value, "trueMoney");
            return (Criteria) this;
        }

        public Criteria andTrueMoneyIn(List<String> values) {
            addCriterion("true_money in", values, "trueMoney");
            return (Criteria) this;
        }

        public Criteria andTrueMoneyNotIn(List<String> values) {
            addCriterion("true_money not in", values, "trueMoney");
            return (Criteria) this;
        }

        public Criteria andTrueMoneyBetween(String value1, String value2) {
            addCriterion("true_money between", value1, value2, "trueMoney");
            return (Criteria) this;
        }

        public Criteria andTrueMoneyNotBetween(String value1, String value2) {
            addCriterion("true_money not between", value1, value2, "trueMoney");
            return (Criteria) this;
        }

        public Criteria andPurchaseStateIsNull() {
            addCriterion("purchase_state is null");
            return (Criteria) this;
        }

        public Criteria andPurchaseStateIsNotNull() {
            addCriterion("purchase_state is not null");
            return (Criteria) this;
        }

        public Criteria andPurchaseStateEqualTo(Integer value) {
            addCriterion("purchase_state =", value, "purchaseState");
            return (Criteria) this;
        }

        public Criteria andPurchaseStateNotEqualTo(Integer value) {
            addCriterion("purchase_state <>", value, "purchaseState");
            return (Criteria) this;
        }

        public Criteria andPurchaseStateGreaterThan(Integer value) {
            addCriterion("purchase_state >", value, "purchaseState");
            return (Criteria) this;
        }

        public Criteria andPurchaseStateGreaterThanOrEqualTo(Integer value) {
            addCriterion("purchase_state >=", value, "purchaseState");
            return (Criteria) this;
        }

        public Criteria andPurchaseStateLessThan(Integer value) {
            addCriterion("purchase_state <", value, "purchaseState");
            return (Criteria) this;
        }

        public Criteria andPurchaseStateLessThanOrEqualTo(Integer value) {
            addCriterion("purchase_state <=", value, "purchaseState");
            return (Criteria) this;
        }

        public Criteria andPurchaseStateIn(List<Integer> values) {
            addCriterion("purchase_state in", values, "purchaseState");
            return (Criteria) this;
        }

        public Criteria andPurchaseStateNotIn(List<Integer> values) {
            addCriterion("purchase_state not in", values, "purchaseState");
            return (Criteria) this;
        }

        public Criteria andPurchaseStateBetween(Integer value1, Integer value2) {
            addCriterion("purchase_state between", value1, value2, "purchaseState");
            return (Criteria) this;
        }

        public Criteria andPurchaseStateNotBetween(Integer value1, Integer value2) {
            addCriterion("purchase_state not between", value1, value2, "purchaseState");
            return (Criteria) this;
        }

        public Criteria andEndTimeIsNull() {
            addCriterion("end_time is null");
            return (Criteria) this;
        }

        public Criteria andEndTimeIsNotNull() {
            addCriterion("end_time is not null");
            return (Criteria) this;
        }

        public Criteria andEndTimeEqualTo(Date value) {
            addCriterion("end_time =", value, "endTime");
            return (Criteria) this;
        }

        public Criteria andEndTimeNotEqualTo(Date value) {
            addCriterion("end_time <>", value, "endTime");
            return (Criteria) this;
        }

        public Criteria andEndTimeGreaterThan(Date value) {
            addCriterion("end_time >", value, "endTime");
            return (Criteria) this;
        }

        public Criteria andEndTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("end_time >=", value, "endTime");
            return (Criteria) this;
        }

        public Criteria andEndTimeLessThan(Date value) {
            addCriterion("end_time <", value, "endTime");
            return (Criteria) this;
        }

        public Criteria andEndTimeLessThanOrEqualTo(Date value) {
            addCriterion("end_time <=", value, "endTime");
            return (Criteria) this;
        }

        public Criteria andEndTimeIn(List<Date> values) {
            addCriterion("end_time in", values, "endTime");
            return (Criteria) this;
        }

        public Criteria andEndTimeNotIn(List<Date> values) {
            addCriterion("end_time not in", values, "endTime");
            return (Criteria) this;
        }

        public Criteria andEndTimeBetween(Date value1, Date value2) {
            addCriterion("end_time between", value1, value2, "endTime");
            return (Criteria) this;
        }

        public Criteria andEndTimeNotBetween(Date value1, Date value2) {
            addCriterion("end_time not between", value1, value2, "endTime");
            return (Criteria) this;
        }

        public Criteria andAddressDetailsIsNull() {
            addCriterion("address_details is null");
            return (Criteria) this;
        }

        public Criteria andAddressDetailsIsNotNull() {
            addCriterion("address_details is not null");
            return (Criteria) this;
        }

        public Criteria andAddressDetailsEqualTo(String value) {
            addCriterion("address_details =", value, "addressDetails");
            return (Criteria) this;
        }

        public Criteria andAddressDetailsNotEqualTo(String value) {
            addCriterion("address_details <>", value, "addressDetails");
            return (Criteria) this;
        }

        public Criteria andAddressDetailsGreaterThan(String value) {
            addCriterion("address_details >", value, "addressDetails");
            return (Criteria) this;
        }

        public Criteria andAddressDetailsGreaterThanOrEqualTo(String value) {
            addCriterion("address_details >=", value, "addressDetails");
            return (Criteria) this;
        }

        public Criteria andAddressDetailsLessThan(String value) {
            addCriterion("address_details <", value, "addressDetails");
            return (Criteria) this;
        }

        public Criteria andAddressDetailsLessThanOrEqualTo(String value) {
            addCriterion("address_details <=", value, "addressDetails");
            return (Criteria) this;
        }

        public Criteria andAddressDetailsLike(String value) {
            addCriterion("address_details like", value, "addressDetails");
            return (Criteria) this;
        }

        public Criteria andAddressDetailsNotLike(String value) {
            addCriterion("address_details not like", value, "addressDetails");
            return (Criteria) this;
        }

        public Criteria andAddressDetailsIn(List<String> values) {
            addCriterion("address_details in", values, "addressDetails");
            return (Criteria) this;
        }

        public Criteria andAddressDetailsNotIn(List<String> values) {
            addCriterion("address_details not in", values, "addressDetails");
            return (Criteria) this;
        }

        public Criteria andAddressDetailsBetween(String value1, String value2) {
            addCriterion("address_details between", value1, value2, "addressDetails");
            return (Criteria) this;
        }

        public Criteria andAddressDetailsNotBetween(String value1, String value2) {
            addCriterion("address_details not between", value1, value2, "addressDetails");
            return (Criteria) this;
        }

        public Criteria andContactsPhoneIsNull() {
            addCriterion("contacts_phone is null");
            return (Criteria) this;
        }

        public Criteria andContactsPhoneIsNotNull() {
            addCriterion("contacts_phone is not null");
            return (Criteria) this;
        }

        public Criteria andContactsPhoneEqualTo(String value) {
            addCriterion("contacts_phone =", value, "contactsPhone");
            return (Criteria) this;
        }

        public Criteria andContactsPhoneNotEqualTo(String value) {
            addCriterion("contacts_phone <>", value, "contactsPhone");
            return (Criteria) this;
        }

        public Criteria andContactsPhoneGreaterThan(String value) {
            addCriterion("contacts_phone >", value, "contactsPhone");
            return (Criteria) this;
        }

        public Criteria andContactsPhoneGreaterThanOrEqualTo(String value) {
            addCriterion("contacts_phone >=", value, "contactsPhone");
            return (Criteria) this;
        }

        public Criteria andContactsPhoneLessThan(String value) {
            addCriterion("contacts_phone <", value, "contactsPhone");
            return (Criteria) this;
        }

        public Criteria andContactsPhoneLessThanOrEqualTo(String value) {
            addCriterion("contacts_phone <=", value, "contactsPhone");
            return (Criteria) this;
        }

        public Criteria andContactsPhoneLike(String value) {
            addCriterion("contacts_phone like", value, "contactsPhone");
            return (Criteria) this;
        }

        public Criteria andContactsPhoneNotLike(String value) {
            addCriterion("contacts_phone not like", value, "contactsPhone");
            return (Criteria) this;
        }

        public Criteria andContactsPhoneIn(List<String> values) {
            addCriterion("contacts_phone in", values, "contactsPhone");
            return (Criteria) this;
        }

        public Criteria andContactsPhoneNotIn(List<String> values) {
            addCriterion("contacts_phone not in", values, "contactsPhone");
            return (Criteria) this;
        }

        public Criteria andContactsPhoneBetween(String value1, String value2) {
            addCriterion("contacts_phone between", value1, value2, "contactsPhone");
            return (Criteria) this;
        }

        public Criteria andContactsPhoneNotBetween(String value1, String value2) {
            addCriterion("contacts_phone not between", value1, value2, "contactsPhone");
            return (Criteria) this;
        }

        public Criteria andPurchaseAddressIsNull() {
            addCriterion("purchase_address is null");
            return (Criteria) this;
        }

        public Criteria andPurchaseAddressIsNotNull() {
            addCriterion("purchase_address is not null");
            return (Criteria) this;
        }

        public Criteria andPurchaseAddressEqualTo(String value) {
            addCriterion("purchase_address =", value, "purchaseAddress");
            return (Criteria) this;
        }

        public Criteria andPurchaseAddressNotEqualTo(String value) {
            addCriterion("purchase_address <>", value, "purchaseAddress");
            return (Criteria) this;
        }

        public Criteria andPurchaseAddressGreaterThan(String value) {
            addCriterion("purchase_address >", value, "purchaseAddress");
            return (Criteria) this;
        }

        public Criteria andPurchaseAddressGreaterThanOrEqualTo(String value) {
            addCriterion("purchase_address >=", value, "purchaseAddress");
            return (Criteria) this;
        }

        public Criteria andPurchaseAddressLessThan(String value) {
            addCriterion("purchase_address <", value, "purchaseAddress");
            return (Criteria) this;
        }

        public Criteria andPurchaseAddressLessThanOrEqualTo(String value) {
            addCriterion("purchase_address <=", value, "purchaseAddress");
            return (Criteria) this;
        }

        public Criteria andPurchaseAddressLike(String value) {
            addCriterion("purchase_address like", value, "purchaseAddress");
            return (Criteria) this;
        }

        public Criteria andPurchaseAddressNotLike(String value) {
            addCriterion("purchase_address not like", value, "purchaseAddress");
            return (Criteria) this;
        }

        public Criteria andPurchaseAddressIn(List<String> values) {
            addCriterion("purchase_address in", values, "purchaseAddress");
            return (Criteria) this;
        }

        public Criteria andPurchaseAddressNotIn(List<String> values) {
            addCriterion("purchase_address not in", values, "purchaseAddress");
            return (Criteria) this;
        }

        public Criteria andPurchaseAddressBetween(String value1, String value2) {
            addCriterion("purchase_address between", value1, value2, "purchaseAddress");
            return (Criteria) this;
        }

        public Criteria andPurchaseAddressNotBetween(String value1, String value2) {
            addCriterion("purchase_address not between", value1, value2, "purchaseAddress");
            return (Criteria) this;
        }

        public Criteria andPurchaseNoteIsNull() {
            addCriterion("purchase_note is null");
            return (Criteria) this;
        }

        public Criteria andPurchaseNoteIsNotNull() {
            addCriterion("purchase_note is not null");
            return (Criteria) this;
        }

        public Criteria andPurchaseNoteEqualTo(String value) {
            addCriterion("purchase_note =", value, "purchaseNote");
            return (Criteria) this;
        }

        public Criteria andPurchaseNoteNotEqualTo(String value) {
            addCriterion("purchase_note <>", value, "purchaseNote");
            return (Criteria) this;
        }

        public Criteria andPurchaseNoteGreaterThan(String value) {
            addCriterion("purchase_note >", value, "purchaseNote");
            return (Criteria) this;
        }

        public Criteria andPurchaseNoteGreaterThanOrEqualTo(String value) {
            addCriterion("purchase_note >=", value, "purchaseNote");
            return (Criteria) this;
        }

        public Criteria andPurchaseNoteLessThan(String value) {
            addCriterion("purchase_note <", value, "purchaseNote");
            return (Criteria) this;
        }

        public Criteria andPurchaseNoteLessThanOrEqualTo(String value) {
            addCriterion("purchase_note <=", value, "purchaseNote");
            return (Criteria) this;
        }

        public Criteria andPurchaseNoteLike(String value) {
            addCriterion("purchase_note like", value, "purchaseNote");
            return (Criteria) this;
        }

        public Criteria andPurchaseNoteNotLike(String value) {
            addCriterion("purchase_note not like", value, "purchaseNote");
            return (Criteria) this;
        }

        public Criteria andPurchaseNoteIn(List<String> values) {
            addCriterion("purchase_note in", values, "purchaseNote");
            return (Criteria) this;
        }

        public Criteria andPurchaseNoteNotIn(List<String> values) {
            addCriterion("purchase_note not in", values, "purchaseNote");
            return (Criteria) this;
        }

        public Criteria andPurchaseNoteBetween(String value1, String value2) {
            addCriterion("purchase_note between", value1, value2, "purchaseNote");
            return (Criteria) this;
        }

        public Criteria andPurchaseNoteNotBetween(String value1, String value2) {
            addCriterion("purchase_note not between", value1, value2, "purchaseNote");
            return (Criteria) this;
        }

        public Criteria andStoreLatitudeIsNull() {
            addCriterion("store_latitude is null");
            return (Criteria) this;
        }

        public Criteria andStoreLatitudeIsNotNull() {
            addCriterion("store_latitude is not null");
            return (Criteria) this;
        }

        public Criteria andStoreLatitudeEqualTo(String value) {
            addCriterion("store_latitude =", value, "storeLatitude");
            return (Criteria) this;
        }

        public Criteria andStoreLatitudeNotEqualTo(String value) {
            addCriterion("store_latitude <>", value, "storeLatitude");
            return (Criteria) this;
        }

        public Criteria andStoreLatitudeGreaterThan(String value) {
            addCriterion("store_latitude >", value, "storeLatitude");
            return (Criteria) this;
        }

        public Criteria andStoreLatitudeGreaterThanOrEqualTo(String value) {
            addCriterion("store_latitude >=", value, "storeLatitude");
            return (Criteria) this;
        }

        public Criteria andStoreLatitudeLessThan(String value) {
            addCriterion("store_latitude <", value, "storeLatitude");
            return (Criteria) this;
        }

        public Criteria andStoreLatitudeLessThanOrEqualTo(String value) {
            addCriterion("store_latitude <=", value, "storeLatitude");
            return (Criteria) this;
        }

        public Criteria andStoreLatitudeLike(String value) {
            addCriterion("store_latitude like", value, "storeLatitude");
            return (Criteria) this;
        }

        public Criteria andStoreLatitudeNotLike(String value) {
            addCriterion("store_latitude not like", value, "storeLatitude");
            return (Criteria) this;
        }

        public Criteria andStoreLatitudeIn(List<String> values) {
            addCriterion("store_latitude in", values, "storeLatitude");
            return (Criteria) this;
        }

        public Criteria andStoreLatitudeNotIn(List<String> values) {
            addCriterion("store_latitude not in", values, "storeLatitude");
            return (Criteria) this;
        }

        public Criteria andStoreLatitudeBetween(String value1, String value2) {
            addCriterion("store_latitude between", value1, value2, "storeLatitude");
            return (Criteria) this;
        }

        public Criteria andStoreLatitudeNotBetween(String value1, String value2) {
            addCriterion("store_latitude not between", value1, value2, "storeLatitude");
            return (Criteria) this;
        }

        public Criteria andStoreLongitudeIsNull() {
            addCriterion("store_longitude is null");
            return (Criteria) this;
        }

        public Criteria andStoreLongitudeIsNotNull() {
            addCriterion("store_longitude is not null");
            return (Criteria) this;
        }

        public Criteria andStoreLongitudeEqualTo(String value) {
            addCriterion("store_longitude =", value, "storeLongitude");
            return (Criteria) this;
        }

        public Criteria andStoreLongitudeNotEqualTo(String value) {
            addCriterion("store_longitude <>", value, "storeLongitude");
            return (Criteria) this;
        }

        public Criteria andStoreLongitudeGreaterThan(String value) {
            addCriterion("store_longitude >", value, "storeLongitude");
            return (Criteria) this;
        }

        public Criteria andStoreLongitudeGreaterThanOrEqualTo(String value) {
            addCriterion("store_longitude >=", value, "storeLongitude");
            return (Criteria) this;
        }

        public Criteria andStoreLongitudeLessThan(String value) {
            addCriterion("store_longitude <", value, "storeLongitude");
            return (Criteria) this;
        }

        public Criteria andStoreLongitudeLessThanOrEqualTo(String value) {
            addCriterion("store_longitude <=", value, "storeLongitude");
            return (Criteria) this;
        }

        public Criteria andStoreLongitudeLike(String value) {
            addCriterion("store_longitude like", value, "storeLongitude");
            return (Criteria) this;
        }

        public Criteria andStoreLongitudeNotLike(String value) {
            addCriterion("store_longitude not like", value, "storeLongitude");
            return (Criteria) this;
        }

        public Criteria andStoreLongitudeIn(List<String> values) {
            addCriterion("store_longitude in", values, "storeLongitude");
            return (Criteria) this;
        }

        public Criteria andStoreLongitudeNotIn(List<String> values) {
            addCriterion("store_longitude not in", values, "storeLongitude");
            return (Criteria) this;
        }

        public Criteria andStoreLongitudeBetween(String value1, String value2) {
            addCriterion("store_longitude between", value1, value2, "storeLongitude");
            return (Criteria) this;
        }

        public Criteria andStoreLongitudeNotBetween(String value1, String value2) {
            addCriterion("store_longitude not between", value1, value2, "storeLongitude");
            return (Criteria) this;
        }

        public Criteria andAddressLatitudeIsNull() {
            addCriterion("address_latitude is null");
            return (Criteria) this;
        }

        public Criteria andAddressLatitudeIsNotNull() {
            addCriterion("address_latitude is not null");
            return (Criteria) this;
        }

        public Criteria andAddressLatitudeEqualTo(String value) {
            addCriterion("address_latitude =", value, "addressLatitude");
            return (Criteria) this;
        }

        public Criteria andAddressLatitudeNotEqualTo(String value) {
            addCriterion("address_latitude <>", value, "addressLatitude");
            return (Criteria) this;
        }

        public Criteria andAddressLatitudeGreaterThan(String value) {
            addCriterion("address_latitude >", value, "addressLatitude");
            return (Criteria) this;
        }

        public Criteria andAddressLatitudeGreaterThanOrEqualTo(String value) {
            addCriterion("address_latitude >=", value, "addressLatitude");
            return (Criteria) this;
        }

        public Criteria andAddressLatitudeLessThan(String value) {
            addCriterion("address_latitude <", value, "addressLatitude");
            return (Criteria) this;
        }

        public Criteria andAddressLatitudeLessThanOrEqualTo(String value) {
            addCriterion("address_latitude <=", value, "addressLatitude");
            return (Criteria) this;
        }

        public Criteria andAddressLatitudeLike(String value) {
            addCriterion("address_latitude like", value, "addressLatitude");
            return (Criteria) this;
        }

        public Criteria andAddressLatitudeNotLike(String value) {
            addCriterion("address_latitude not like", value, "addressLatitude");
            return (Criteria) this;
        }

        public Criteria andAddressLatitudeIn(List<String> values) {
            addCriterion("address_latitude in", values, "addressLatitude");
            return (Criteria) this;
        }

        public Criteria andAddressLatitudeNotIn(List<String> values) {
            addCriterion("address_latitude not in", values, "addressLatitude");
            return (Criteria) this;
        }

        public Criteria andAddressLatitudeBetween(String value1, String value2) {
            addCriterion("address_latitude between", value1, value2, "addressLatitude");
            return (Criteria) this;
        }

        public Criteria andAddressLatitudeNotBetween(String value1, String value2) {
            addCriterion("address_latitude not between", value1, value2, "addressLatitude");
            return (Criteria) this;
        }

        public Criteria andAddressLongitudeIsNull() {
            addCriterion("address_longitude is null");
            return (Criteria) this;
        }

        public Criteria andAddressLongitudeIsNotNull() {
            addCriterion("address_longitude is not null");
            return (Criteria) this;
        }

        public Criteria andAddressLongitudeEqualTo(String value) {
            addCriterion("address_longitude =", value, "addressLongitude");
            return (Criteria) this;
        }

        public Criteria andAddressLongitudeNotEqualTo(String value) {
            addCriterion("address_longitude <>", value, "addressLongitude");
            return (Criteria) this;
        }

        public Criteria andAddressLongitudeGreaterThan(String value) {
            addCriterion("address_longitude >", value, "addressLongitude");
            return (Criteria) this;
        }

        public Criteria andAddressLongitudeGreaterThanOrEqualTo(String value) {
            addCriterion("address_longitude >=", value, "addressLongitude");
            return (Criteria) this;
        }

        public Criteria andAddressLongitudeLessThan(String value) {
            addCriterion("address_longitude <", value, "addressLongitude");
            return (Criteria) this;
        }

        public Criteria andAddressLongitudeLessThanOrEqualTo(String value) {
            addCriterion("address_longitude <=", value, "addressLongitude");
            return (Criteria) this;
        }

        public Criteria andAddressLongitudeLike(String value) {
            addCriterion("address_longitude like", value, "addressLongitude");
            return (Criteria) this;
        }

        public Criteria andAddressLongitudeNotLike(String value) {
            addCriterion("address_longitude not like", value, "addressLongitude");
            return (Criteria) this;
        }

        public Criteria andAddressLongitudeIn(List<String> values) {
            addCriterion("address_longitude in", values, "addressLongitude");
            return (Criteria) this;
        }

        public Criteria andAddressLongitudeNotIn(List<String> values) {
            addCriterion("address_longitude not in", values, "addressLongitude");
            return (Criteria) this;
        }

        public Criteria andAddressLongitudeBetween(String value1, String value2) {
            addCriterion("address_longitude between", value1, value2, "addressLongitude");
            return (Criteria) this;
        }

        public Criteria andAddressLongitudeNotBetween(String value1, String value2) {
            addCriterion("address_longitude not between", value1, value2, "addressLongitude");
            return (Criteria) this;
        }

        public Criteria andPurchaseLatitudeIsNull() {
            addCriterion("purchase_latitude is null");
            return (Criteria) this;
        }

        public Criteria andPurchaseLatitudeIsNotNull() {
            addCriterion("purchase_latitude is not null");
            return (Criteria) this;
        }

        public Criteria andPurchaseLatitudeEqualTo(String value) {
            addCriterion("purchase_latitude =", value, "purchaseLatitude");
            return (Criteria) this;
        }

        public Criteria andPurchaseLatitudeNotEqualTo(String value) {
            addCriterion("purchase_latitude <>", value, "purchaseLatitude");
            return (Criteria) this;
        }

        public Criteria andPurchaseLatitudeGreaterThan(String value) {
            addCriterion("purchase_latitude >", value, "purchaseLatitude");
            return (Criteria) this;
        }

        public Criteria andPurchaseLatitudeGreaterThanOrEqualTo(String value) {
            addCriterion("purchase_latitude >=", value, "purchaseLatitude");
            return (Criteria) this;
        }

        public Criteria andPurchaseLatitudeLessThan(String value) {
            addCriterion("purchase_latitude <", value, "purchaseLatitude");
            return (Criteria) this;
        }

        public Criteria andPurchaseLatitudeLessThanOrEqualTo(String value) {
            addCriterion("purchase_latitude <=", value, "purchaseLatitude");
            return (Criteria) this;
        }

        public Criteria andPurchaseLatitudeLike(String value) {
            addCriterion("purchase_latitude like", value, "purchaseLatitude");
            return (Criteria) this;
        }

        public Criteria andPurchaseLatitudeNotLike(String value) {
            addCriterion("purchase_latitude not like", value, "purchaseLatitude");
            return (Criteria) this;
        }

        public Criteria andPurchaseLatitudeIn(List<String> values) {
            addCriterion("purchase_latitude in", values, "purchaseLatitude");
            return (Criteria) this;
        }

        public Criteria andPurchaseLatitudeNotIn(List<String> values) {
            addCriterion("purchase_latitude not in", values, "purchaseLatitude");
            return (Criteria) this;
        }

        public Criteria andPurchaseLatitudeBetween(String value1, String value2) {
            addCriterion("purchase_latitude between", value1, value2, "purchaseLatitude");
            return (Criteria) this;
        }

        public Criteria andPurchaseLatitudeNotBetween(String value1, String value2) {
            addCriterion("purchase_latitude not between", value1, value2, "purchaseLatitude");
            return (Criteria) this;
        }

        public Criteria andPurchaseLongitudeIsNull() {
            addCriterion("purchase_longitude is null");
            return (Criteria) this;
        }

        public Criteria andPurchaseLongitudeIsNotNull() {
            addCriterion("purchase_longitude is not null");
            return (Criteria) this;
        }

        public Criteria andPurchaseLongitudeEqualTo(String value) {
            addCriterion("purchase_longitude =", value, "purchaseLongitude");
            return (Criteria) this;
        }

        public Criteria andPurchaseLongitudeNotEqualTo(String value) {
            addCriterion("purchase_longitude <>", value, "purchaseLongitude");
            return (Criteria) this;
        }

        public Criteria andPurchaseLongitudeGreaterThan(String value) {
            addCriterion("purchase_longitude >", value, "purchaseLongitude");
            return (Criteria) this;
        }

        public Criteria andPurchaseLongitudeGreaterThanOrEqualTo(String value) {
            addCriterion("purchase_longitude >=", value, "purchaseLongitude");
            return (Criteria) this;
        }

        public Criteria andPurchaseLongitudeLessThan(String value) {
            addCriterion("purchase_longitude <", value, "purchaseLongitude");
            return (Criteria) this;
        }

        public Criteria andPurchaseLongitudeLessThanOrEqualTo(String value) {
            addCriterion("purchase_longitude <=", value, "purchaseLongitude");
            return (Criteria) this;
        }

        public Criteria andPurchaseLongitudeLike(String value) {
            addCriterion("purchase_longitude like", value, "purchaseLongitude");
            return (Criteria) this;
        }

        public Criteria andPurchaseLongitudeNotLike(String value) {
            addCriterion("purchase_longitude not like", value, "purchaseLongitude");
            return (Criteria) this;
        }

        public Criteria andPurchaseLongitudeIn(List<String> values) {
            addCriterion("purchase_longitude in", values, "purchaseLongitude");
            return (Criteria) this;
        }

        public Criteria andPurchaseLongitudeNotIn(List<String> values) {
            addCriterion("purchase_longitude not in", values, "purchaseLongitude");
            return (Criteria) this;
        }

        public Criteria andPurchaseLongitudeBetween(String value1, String value2) {
            addCriterion("purchase_longitude between", value1, value2, "purchaseLongitude");
            return (Criteria) this;
        }

        public Criteria andPurchaseLongitudeNotBetween(String value1, String value2) {
            addCriterion("purchase_longitude not between", value1, value2, "purchaseLongitude");
            return (Criteria) this;
        }

        public Criteria andDemandPayPriceIsNull() {
            addCriterion("demand_pay_price is null");
            return (Criteria) this;
        }

        public Criteria andDemandPayPriceIsNotNull() {
            addCriterion("demand_pay_price is not null");
            return (Criteria) this;
        }

        public Criteria andDemandPayPriceEqualTo(String value) {
            addCriterion("demand_pay_price =", value, "demandPayPrice");
            return (Criteria) this;
        }

        public Criteria andDemandPayPriceNotEqualTo(String value) {
            addCriterion("demand_pay_price <>", value, "demandPayPrice");
            return (Criteria) this;
        }

        public Criteria andDemandPayPriceGreaterThan(String value) {
            addCriterion("demand_pay_price >", value, "demandPayPrice");
            return (Criteria) this;
        }

        public Criteria andDemandPayPriceGreaterThanOrEqualTo(String value) {
            addCriterion("demand_pay_price >=", value, "demandPayPrice");
            return (Criteria) this;
        }

        public Criteria andDemandPayPriceLessThan(String value) {
            addCriterion("demand_pay_price <", value, "demandPayPrice");
            return (Criteria) this;
        }

        public Criteria andDemandPayPriceLessThanOrEqualTo(String value) {
            addCriterion("demand_pay_price <=", value, "demandPayPrice");
            return (Criteria) this;
        }

        public Criteria andDemandPayPriceLike(String value) {
            addCriterion("demand_pay_price like", value, "demandPayPrice");
            return (Criteria) this;
        }

        public Criteria andDemandPayPriceNotLike(String value) {
            addCriterion("demand_pay_price not like", value, "demandPayPrice");
            return (Criteria) this;
        }

        public Criteria andDemandPayPriceIn(List<String> values) {
            addCriterion("demand_pay_price in", values, "demandPayPrice");
            return (Criteria) this;
        }

        public Criteria andDemandPayPriceNotIn(List<String> values) {
            addCriterion("demand_pay_price not in", values, "demandPayPrice");
            return (Criteria) this;
        }

        public Criteria andDemandPayPriceBetween(String value1, String value2) {
            addCriterion("demand_pay_price between", value1, value2, "demandPayPrice");
            return (Criteria) this;
        }

        public Criteria andDemandPayPriceNotBetween(String value1, String value2) {
            addCriterion("demand_pay_price not between", value1, value2, "demandPayPrice");
            return (Criteria) this;
        }

        public Criteria andUserVouchersIdIsNull() {
            addCriterion("user_vouchers_id is null");
            return (Criteria) this;
        }

        public Criteria andUserVouchersIdIsNotNull() {
            addCriterion("user_vouchers_id is not null");
            return (Criteria) this;
        }

        public Criteria andUserVouchersIdEqualTo(Integer value) {
            addCriterion("user_vouchers_id =", value, "userVouchersId");
            return (Criteria) this;
        }

        public Criteria andUserVouchersIdNotEqualTo(Integer value) {
            addCriterion("user_vouchers_id <>", value, "userVouchersId");
            return (Criteria) this;
        }

        public Criteria andUserVouchersIdGreaterThan(Integer value) {
            addCriterion("user_vouchers_id >", value, "userVouchersId");
            return (Criteria) this;
        }

        public Criteria andUserVouchersIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("user_vouchers_id >=", value, "userVouchersId");
            return (Criteria) this;
        }

        public Criteria andUserVouchersIdLessThan(Integer value) {
            addCriterion("user_vouchers_id <", value, "userVouchersId");
            return (Criteria) this;
        }

        public Criteria andUserVouchersIdLessThanOrEqualTo(Integer value) {
            addCriterion("user_vouchers_id <=", value, "userVouchersId");
            return (Criteria) this;
        }

        public Criteria andUserVouchersIdIn(List<Integer> values) {
            addCriterion("user_vouchers_id in", values, "userVouchersId");
            return (Criteria) this;
        }

        public Criteria andUserVouchersIdNotIn(List<Integer> values) {
            addCriterion("user_vouchers_id not in", values, "userVouchersId");
            return (Criteria) this;
        }

        public Criteria andUserVouchersIdBetween(Integer value1, Integer value2) {
            addCriterion("user_vouchers_id between", value1, value2, "userVouchersId");
            return (Criteria) this;
        }

        public Criteria andUserVouchersIdNotBetween(Integer value1, Integer value2) {
            addCriterion("user_vouchers_id not between", value1, value2, "userVouchersId");
            return (Criteria) this;
        }

        public Criteria andPurchaseUseVouchaseIdIsNull() {
            addCriterion("purchase_use_vouchase_id is null");
            return (Criteria) this;
        }

        public Criteria andPurchaseUseVouchaseIdIsNotNull() {
            addCriterion("purchase_use_vouchase_id is not null");
            return (Criteria) this;
        }

        public Criteria andPurchaseUseVouchaseIdEqualTo(Integer value) {
            addCriterion("purchase_use_vouchase_id =", value, "purchaseUseVouchaseId");
            return (Criteria) this;
        }

        public Criteria andPurchaseUseVouchaseIdNotEqualTo(Integer value) {
            addCriterion("purchase_use_vouchase_id <>", value, "purchaseUseVouchaseId");
            return (Criteria) this;
        }

        public Criteria andPurchaseUseVouchaseIdGreaterThan(Integer value) {
            addCriterion("purchase_use_vouchase_id >", value, "purchaseUseVouchaseId");
            return (Criteria) this;
        }

        public Criteria andPurchaseUseVouchaseIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("purchase_use_vouchase_id >=", value, "purchaseUseVouchaseId");
            return (Criteria) this;
        }

        public Criteria andPurchaseUseVouchaseIdLessThan(Integer value) {
            addCriterion("purchase_use_vouchase_id <", value, "purchaseUseVouchaseId");
            return (Criteria) this;
        }

        public Criteria andPurchaseUseVouchaseIdLessThanOrEqualTo(Integer value) {
            addCriterion("purchase_use_vouchase_id <=", value, "purchaseUseVouchaseId");
            return (Criteria) this;
        }

        public Criteria andPurchaseUseVouchaseIdIn(List<Integer> values) {
            addCriterion("purchase_use_vouchase_id in", values, "purchaseUseVouchaseId");
            return (Criteria) this;
        }

        public Criteria andPurchaseUseVouchaseIdNotIn(List<Integer> values) {
            addCriterion("purchase_use_vouchase_id not in", values, "purchaseUseVouchaseId");
            return (Criteria) this;
        }

        public Criteria andPurchaseUseVouchaseIdBetween(Integer value1, Integer value2) {
            addCriterion("purchase_use_vouchase_id between", value1, value2, "purchaseUseVouchaseId");
            return (Criteria) this;
        }

        public Criteria andPurchaseUseVouchaseIdNotBetween(Integer value1, Integer value2) {
            addCriterion("purchase_use_vouchase_id not between", value1, value2, "purchaseUseVouchaseId");
            return (Criteria) this;
        }

        public Criteria andPurchasePayCourierPriceIsNull() {
            addCriterion("purchase_pay_courier_price is null");
            return (Criteria) this;
        }

        public Criteria andPurchasePayCourierPriceIsNotNull() {
            addCriterion("purchase_pay_courier_price is not null");
            return (Criteria) this;
        }

        public Criteria andPurchasePayCourierPriceEqualTo(String value) {
            addCriterion("purchase_pay_courier_price =", value, "purchasePayCourierPrice");
            return (Criteria) this;
        }

        public Criteria andPurchasePayCourierPriceNotEqualTo(String value) {
            addCriterion("purchase_pay_courier_price <>", value, "purchasePayCourierPrice");
            return (Criteria) this;
        }

        public Criteria andPurchasePayCourierPriceGreaterThan(String value) {
            addCriterion("purchase_pay_courier_price >", value, "purchasePayCourierPrice");
            return (Criteria) this;
        }

        public Criteria andPurchasePayCourierPriceGreaterThanOrEqualTo(String value) {
            addCriterion("purchase_pay_courier_price >=", value, "purchasePayCourierPrice");
            return (Criteria) this;
        }

        public Criteria andPurchasePayCourierPriceLessThan(String value) {
            addCriterion("purchase_pay_courier_price <", value, "purchasePayCourierPrice");
            return (Criteria) this;
        }

        public Criteria andPurchasePayCourierPriceLessThanOrEqualTo(String value) {
            addCriterion("purchase_pay_courier_price <=", value, "purchasePayCourierPrice");
            return (Criteria) this;
        }

        public Criteria andPurchasePayCourierPriceLike(String value) {
            addCriterion("purchase_pay_courier_price like", value, "purchasePayCourierPrice");
            return (Criteria) this;
        }

        public Criteria andPurchasePayCourierPriceNotLike(String value) {
            addCriterion("purchase_pay_courier_price not like", value, "purchasePayCourierPrice");
            return (Criteria) this;
        }

        public Criteria andPurchasePayCourierPriceIn(List<String> values) {
            addCriterion("purchase_pay_courier_price in", values, "purchasePayCourierPrice");
            return (Criteria) this;
        }

        public Criteria andPurchasePayCourierPriceNotIn(List<String> values) {
            addCriterion("purchase_pay_courier_price not in", values, "purchasePayCourierPrice");
            return (Criteria) this;
        }

        public Criteria andPurchasePayCourierPriceBetween(String value1, String value2) {
            addCriterion("purchase_pay_courier_price between", value1, value2, "purchasePayCourierPrice");
            return (Criteria) this;
        }

        public Criteria andPurchasePayCourierPriceNotBetween(String value1, String value2) {
            addCriterion("purchase_pay_courier_price not between", value1, value2, "purchasePayCourierPrice");
            return (Criteria) this;
        }

        public Criteria andPurchaseFindCourierTimeIsNull() {
            addCriterion("purchase_find_courier_time is null");
            return (Criteria) this;
        }

        public Criteria andPurchaseFindCourierTimeIsNotNull() {
            addCriterion("purchase_find_courier_time is not null");
            return (Criteria) this;
        }

        public Criteria andPurchaseFindCourierTimeEqualTo(Date value) {
            addCriterion("purchase_find_courier_time =", value, "purchaseFindCourierTime");
            return (Criteria) this;
        }

        public Criteria andPurchaseFindCourierTimeNotEqualTo(Date value) {
            addCriterion("purchase_find_courier_time <>", value, "purchaseFindCourierTime");
            return (Criteria) this;
        }

        public Criteria andPurchaseFindCourierTimeGreaterThan(Date value) {
            addCriterion("purchase_find_courier_time >", value, "purchaseFindCourierTime");
            return (Criteria) this;
        }

        public Criteria andPurchaseFindCourierTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("purchase_find_courier_time >=", value, "purchaseFindCourierTime");
            return (Criteria) this;
        }

        public Criteria andPurchaseFindCourierTimeLessThan(Date value) {
            addCriterion("purchase_find_courier_time <", value, "purchaseFindCourierTime");
            return (Criteria) this;
        }

        public Criteria andPurchaseFindCourierTimeLessThanOrEqualTo(Date value) {
            addCriterion("purchase_find_courier_time <=", value, "purchaseFindCourierTime");
            return (Criteria) this;
        }

        public Criteria andPurchaseFindCourierTimeIn(List<Date> values) {
            addCriterion("purchase_find_courier_time in", values, "purchaseFindCourierTime");
            return (Criteria) this;
        }

        public Criteria andPurchaseFindCourierTimeNotIn(List<Date> values) {
            addCriterion("purchase_find_courier_time not in", values, "purchaseFindCourierTime");
            return (Criteria) this;
        }

        public Criteria andPurchaseFindCourierTimeBetween(Date value1, Date value2) {
            addCriterion("purchase_find_courier_time between", value1, value2, "purchaseFindCourierTime");
            return (Criteria) this;
        }

        public Criteria andPurchaseFindCourierTimeNotBetween(Date value1, Date value2) {
            addCriterion("purchase_find_courier_time not between", value1, value2, "purchaseFindCourierTime");
            return (Criteria) this;
        }

        public Criteria andOrderEndTimeIsNull() {
            addCriterion("order_end_time is null");
            return (Criteria) this;
        }

        public Criteria andOrderEndTimeIsNotNull() {
            addCriterion("order_end_time is not null");
            return (Criteria) this;
        }

        public Criteria andOrderEndTimeEqualTo(Date value) {
            addCriterion("order_end_time =", value, "orderEndTime");
            return (Criteria) this;
        }

        public Criteria andOrderEndTimeNotEqualTo(Date value) {
            addCriterion("order_end_time <>", value, "orderEndTime");
            return (Criteria) this;
        }

        public Criteria andOrderEndTimeGreaterThan(Date value) {
            addCriterion("order_end_time >", value, "orderEndTime");
            return (Criteria) this;
        }

        public Criteria andOrderEndTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("order_end_time >=", value, "orderEndTime");
            return (Criteria) this;
        }

        public Criteria andOrderEndTimeLessThan(Date value) {
            addCriterion("order_end_time <", value, "orderEndTime");
            return (Criteria) this;
        }

        public Criteria andOrderEndTimeLessThanOrEqualTo(Date value) {
            addCriterion("order_end_time <=", value, "orderEndTime");
            return (Criteria) this;
        }

        public Criteria andOrderEndTimeIn(List<Date> values) {
            addCriterion("order_end_time in", values, "orderEndTime");
            return (Criteria) this;
        }

        public Criteria andOrderEndTimeNotIn(List<Date> values) {
            addCriterion("order_end_time not in", values, "orderEndTime");
            return (Criteria) this;
        }

        public Criteria andOrderEndTimeBetween(Date value1, Date value2) {
            addCriterion("order_end_time between", value1, value2, "orderEndTime");
            return (Criteria) this;
        }

        public Criteria andOrderEndTimeNotBetween(Date value1, Date value2) {
            addCriterion("order_end_time not between", value1, value2, "orderEndTime");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}